<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="UTF-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <title>列过滤器</title>
  <script src="./js/jexcel.js"></script>
  <script src="./js/jsuites.js"></script>
  <link rel="stylesheet" href="./css/jsuites.css" type="text/css" />
  <link rel="stylesheet" href="./css/jexcel.css" type="text/css" />
</head>

<body>
  <h1>列过滤器</h1>

  <div id="spreadsheet"></div>
</body>
<script>
  var data1 = [
    ['US', 'Cheese', '2019-02-12'],
    ['CA', 'Apples', '2019-03-01'],
    ['CA', 'Carrots', '2018-11-10'],
    ['BR', 'Oranges', '2019-01-12'],
  ];

  let mySpreadsheet = jspreadsheet(document.getElementById('spreadsheet'), {
    data: data1,
    columns: [
      {
        type: 'dropdown',
        url: './static/countries.json',
        width: 200,
      },
      {
        type: 'text',
        width: 200,
      },
      {
        type: 'calendar',
        width: 200,
      },
      {
        type: 'checkbox',
        width: 200,
      }
    ],
    filters: true,
    allowComments: true,
  });
</script>

</html>